Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# REMCHARS

The REMCHARS function removes one or more characters from a text expression and returns the value that remains.

Tip: When you are using a multibyte character set, you can use the REMBYTES function instead of the REMCHARS function.

Return Value

TEXT or NTEXT

Syntax

REMCHARS(text-expression start [length])

Arguments

text-expression

  The expression from which REMCHARS removes characters. When the characters to remove from text-expression contain embedded line breaks, these breaks are also removed. Other line breaks are preserved. Removed line breaks are not counted toward the total number of characters removed.

  When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.

start

  An `INTEGER` that represents the character position at which to begin removing characters. The position of the first character in text-expression is `1`. When the value of start is greater than the length of text-expression, REMCHARS simply returns text-expression.

length

  An `INTEGER` that represents the number of characters to be removed. When length is not specified, only the character at start is removed.

Examples

Example 20-17 Using REMCHARS to Remove a Substring

This example shows how to remove the substring `there` from the text value `hellotherejoe`.

The statement

    SHOW REMCHARS('hellotherejoe', 6, 5)

produces the following output.

    hellojoe

Example 20-18 Removing a Single Character

This example shows how to remove the character `t` from the text value `hellotherejoe`.

    SHOW REMCHARS('hellotherejoe', 6)

produces the following output.

    helloherejoe